```html
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>MySQL存储引擎对比：InnoDB vs MyISAM</title>
    <link rel="stylesheet" href="https://cdn.staticfile.org/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="https://cdn.staticfile.org/tailwindcss/2.2.19/tailwind.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Noto+Serif+SC:wght@400;500;600;700&family=Noto+Sans+SC:wght@300;400;500;700&display=swap" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/mermaid@latest/dist/mermaid.min.js"></script>
    <style>
        body {
            font-family: 'Noto Sans SC', Tahoma, Arial, Roboto, "Droid Sans", "Helvetica Neue", "Droid Sans Fallback", "Heiti SC", "Hiragino Sans GB", Simsun, sans-serif;
            color: #333;
            line-height: 1.6;
        }
        h1, h2, h3, h4 {
            font-family: 'Noto Serif SC', serif;
            font-weight: 600;
            color: #2d3748;
        }
        .hero {
            background: linear-gradient(135deg, #4299e1 0%, #3182ce 100%);
            color: white;
        }
        .card {
            transition: all 0.3s ease;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }
        .card:hover {
            transform: translateY(-5px);
            box-shadow: 0 10px 15px rgba(0, 0, 0, 0.1);
        }
        .feature-icon {
            font-size: 2.5rem;
            color: #4299e1;
            margin-bottom: 1rem;
        }
        .divider {
            height: 3px;
            background: linear-gradient(90deg, #4299e1 0%, #38b2ac 100%);
            margin: 2rem 0;
            border-radius: 3px;
        }
        .comparison-table th, .comparison-table td {
            padding: 12px 15px;
        }
        .comparison-table tr:nth-child(even) {
            background-color: #f8fafc;
        }
        .tooltip {
            position: relative;
            display: inline-block;
            cursor: pointer;
        }
        .tooltip .tooltiptext {
            visibility: hidden;
            width: 200px;
            background-color: #2d3748;
            color: #fff;
            text-align: center;
            border-radius: 6px;
            padding: 10px;
            position: absolute;
            z-index: 1;
            bottom: 125%;
            left: 50%;
            transform: translateX(-50%);
            opacity: 0;
            transition: opacity 0.3s;
        }
        .tooltip:hover .tooltiptext {
            visibility: visible;
            opacity: 1;
        }
    </style>
</head>
<body class="bg-gray-50">
    <!-- Hero Section -->
    <section class="hero py-20 px-4 md:px-0">
        <div class="container mx-auto max-w-5xl text-center">
            <h1 class="text-4xl md:text-5xl font-bold mb-6">MySQL存储引擎对比</h1>
            <h2 class="text-3xl md:text-4xl font-bold mb-8">InnoDB vs MyISAM</h2>
            <p class="text-xl md:text-2xl opacity-90 mb-10 max-w-3xl mx-auto">
                深入解析两大主流MySQL存储引擎的核心差异，帮助您为应用选择最佳解决方案
            </p>
            <div class="flex justify-center space-x-4">
                <div class="bg-white text-blue-600 px-6 py-3 rounded-full font-bold shadow-lg">事务支持</div>
                <div class="bg-white text-blue-600 px-6 py-3 rounded-full font-bold shadow-lg">性能优化</div>
                <div class="bg-white text-blue-600 px-6 py-3 rounded-full font-bold shadow-lg">应用场景</div>
            </div>
        </div>
    </section>

    <!-- Main Content -->
    <main class="container mx-auto max-w-5xl px-4 py-12">
        <!-- Introduction -->
        <section class="mb-16">
            <div class="bg-white rounded-xl p-8 shadow-lg card">
                <h2 class="text-3xl font-bold mb-6 text-blue-800">存储引擎概述</h2>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713234010385-5ac06b1e-1637-4256-adfc-e0501298a137.png" alt="InnoDB vs MyISAM" class="w-full h-auto rounded-lg mb-4">
                    </div>
                    <div>
                        <p class="mb-4 text-gray-700 leading-relaxed">
                            MySQL数据库中的InnoDB和MyISAM是两种最常用的存储引擎，它们在功能、性能和适用场景等方面存在显著的区别。选择合适的存储引擎对应用的性能、可靠性和可维护性至关重要。
                        </p>
                        <p class="text-gray-700 leading-relaxed">
                            InnoDB支持事务处理和ACID属性，适合需要数据完整性和一致性的应用。MyISAM则更简单轻量，适合读取密集型的应用场景。
                        </p>
                    </div>
                </div>
            </div>
        </section>

        <!-- Key Differences -->
        <section class="mb-16">
            <h2 class="text-3xl font-bold mb-8 text-center text-blue-800">核心差异对比</h2>
            
            <!-- Transaction Support -->
            <div class="bg-white rounded-xl p-8 shadow-lg mb-8 card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-exchange-alt feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">事务支持</h3>
                </div>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>支持完整的ACID事务特性</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>确保数据的一致性和完整性</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>支持回滚和提交操作</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-red-600">MyISAM</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>不支持事务处理</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>每个SQL语句自动提交</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>崩溃时可能导致数据不一致</span>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713234089393-38ce9d18-c4dc-4240-b354-5617c614cc38.png" alt="事务支持对比" class="w-full h-auto rounded-lg">
                </div>
            </div>

            <!-- Locking Mechanism -->
            <div class="bg-white rounded-xl p-8 shadow-lg mb-8 card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-lock feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">锁定机制</h3>
                </div>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>行级锁定，只锁定受影响的行</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>更高的并发性能</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>减少死锁发生概率</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-red-600">MyISAM</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>表级锁定，锁定整个表</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>并发性能较低</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>高并发下易出现性能瓶颈</span>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713234167130-ffa2a239-5f04-44d5-8f3f-ef0826eb3a71.png" alt="锁定机制对比" class="w-full h-auto rounded-lg">
                </div>
            </div>

            <!-- Foreign Keys -->
            <div class="bg-white rounded-xl p-8 shadow-lg mb-8 card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-link feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">外键约束</h3>
                </div>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>支持外键约束</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>确保数据引用完整性</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>自动维护表间关系</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-red-600">MyISAM</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>不支持外键约束</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>需在应用层维护数据关系</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>可能导致数据不一致</span>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713234339916-2631c7ce-6e0f-42bb-99c6-181c03e83336.png" alt="外键约束对比" class="w-full h-auto rounded-lg">
                </div>
            </div>

            <!-- Performance -->
            <div class="bg-white rounded-xl p-8 shadow-lg mb-8 card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-tachometer-alt feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">性能特征</h3>
                </div>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>写密集型应用性能更优</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>高并发访问表现良好</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>崩溃恢复能力强</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-red-600">MyISAM</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-blue-500 mt-1 mr-2"></i>
                                <span>读密集型应用性能更优</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-blue-500 mt-1 mr-2"></i>
                                <span>全表扫描速度快</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>崩溃恢复能力较弱</span>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713234858430-68f4842f-3174-437f-bd50-e5e7740c0a10.png" alt="性能特征对比" class="w-full h-auto rounded-lg">
                </div>
            </div>

            <!-- Storage and Caching -->
            <div class="bg-white rounded-xl p-8 shadow-lg mb-8 card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-database feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">存储与缓存</h3>
                </div>
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>使用缓冲池(Buffer Pool)缓存数据</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>磁盘占用相对较大</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-green-500 mt-1 mr-2"></i>
                                <span>支持表空间管理</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-red-600">MyISAM</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-blue-500 mt-1 mr-2"></i>
                                <span>依赖操作系统文件缓存</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-blue-500 mt-1 mr-2"></i>
                                <span>磁盘占用相对较小</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-times text-red-500 mt-1 mr-2"></i>
                                <span>高并发下缓存争用问题</span>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713235660503-b66f9282-b7ee-4117-bb62-b8dfee7090f7.png" alt="存储与缓存对比" class="w-full h-auto rounded-lg">
                </div>
            </div>
        </section>

        <!-- Use Cases -->
        <section class="mb-16">
            <h2 class="text-3xl font-bold mb-8 text-center text-blue-800">适用场景</h2>
            
            <div class="grid md:grid-cols-2 gap-8">
                <div class="bg-green-50 rounded-xl p-8 shadow-lg card">
                    <h3 class="text-2xl font-bold mb-4 text-green-700">InnoDB适用场景</h3>
                    <ul class="space-y-4">
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-green-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">金融系统</h4>
                                <p class="text-gray-700">需要事务支持和数据一致性的关键业务系统</p>
                            </div>
                        </li>
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-green-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">电子商务平台</h4>
                                <p class="text-gray-700">处理订单、支付等高并发写操作</p>
                            </div>
                        </li>
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-green-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">内容管理系统</h4>
                                <p class="text-gray-700">需要维护复杂数据关系的系统</p>
                            </div>
                        </li>
                    </ul>
                </div>
                
                <div class="bg-blue-50 rounded-xl p-8 shadow-lg card">
                    <h3 class="text-2xl font-bold mb-4 text-blue-700">MyISAM适用场景</h3>
                    <ul class="space-y-4">
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-blue-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">博客系统</h4>
                                <p class="text-gray-700">读取频率高，写入频率低的场景</p>
                            </div>
                        </li>
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-blue-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">新闻网站</h4>
                                <p class="text-gray-700">大量内容展示，少量更新的系统</p>
                            </div>
                        </li>
                        <li class="flex items-start">
                            <i class="fas fa-check-circle text-blue-500 mt-1 mr-3"></i>
                            <div>
                                <h4 class="font-bold">日志分析</h4>
                                <p class="text-gray-700">需要全文索引的文本搜索场景</p>
                            </div>
                        </li>
                    </ul>
                </div>
            </div>
        </section>

        <!-- Feature Comparison -->
        <section class="mb-16">
            <h2 class="text-3xl font-bold mb-8 text-center text-blue-800">特性对比</h2>
            
            <div class="bg-white rounded-xl p-8 shadow-lg card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-star feature-icon mr-4"></i>
                    <h3 class="text-2xl font-bold">特有功能</h3>
                </div>
                
                <div class="grid md:grid-cols-2 gap-8 mb-8">
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-green-600">InnoDB特有功能</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-green-500 mt-1 mr-2"></i>
                                <span>事务处理(ACID)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-green-500 mt-1 mr-2"></i>
                                <span>行级锁定</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-green-500 mt-1 mr-2"></i>
                                <span>外键约束</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-green-500 mt-1 mr-2"></i>
                                <span>崩溃恢复</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-green-500 mt-1 mr-2"></i>
                                <span>MVCC(多版本并发控制)</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-3 text-blue-600">MyISAM特有功能</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-blue-500 mt-1 mr-2"></i>
                                <span>全文索引(MySQL 5.6前独占)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-blue-500 mt-1 mr-2"></i>
                                <span>表级锁定</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-blue-500 mt-1 mr-2"></i>
                                <span>更小的存储空间占用</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-blue-500 mt-1 mr-2"></i>
                                <span>COUNT(*)操作优化</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check-double text-blue-500 mt-1 mr-2"></i>
                                <span>更简单的表结构</span>
                            </li>
                        </ul>
                    </div>
                </div>
                
                <div class="mt-8">
                    <img src="https://cdn.nlark.com/yuque/0/2024/png/21449790/1713235750605-434e019f-1f6d-48e6-96e4-ef7b4ffcbcc9.png" alt="特性对比" class="w-full h-auto rounded-lg">
                </div>
            </div>
        </section>

        <!-- Detailed Comparison Table -->
        <section class="mb-16">
            <h2 class="text-3xl font-bold mb-8 text-center text-blue-800">详细对比表</h2>
            
            <div class="bg-white rounded-xl shadow-lg overflow-hidden">
                <table class="w-full comparison-table">
                    <thead class="bg-blue-600 text-white">
                        <tr>
                            <th class="text-left py-4 px-6">特性</th>
                            <th class="text-center py-4 px-6">MyISAM</th>
                            <th class="text-center py-4 px-6">InnoDB</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td class="py-4 px-6 font-medium">存储结构</td>
                            <td class="py-4 px-6 text-center">
                                每张表被存放在三个文件：<br>
                                frm(表结构定义)<br>
                                MYD(数据文件)<br>
                                MYI(索引文件)
                            </td>
                            <td class="py-4 px-6 text-center">
                                所有表数据保存在同一个数据文件中<br>
                                表大小受限于操作系统文件大小(通常2GB)
                            </td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">存储空间</td>
                            <td class="py-4 px-6 text-center">可被压缩，存储空间较小</td>
                            <td class="py-4 px-6 text-center">需要更多内存和存储，使用缓冲池</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">文件格式</td>
                            <td class="py-4 px-6 text-center">数据和索引分别存储(.MYD, .MYI)</td>
                            <td class="py-4 px-6 text-center">数据和索引集中存储(.ibd)</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">记录存储顺序</td>
                            <td class="py-4 px-6 text-center">按记录插入顺序保存</td>
                            <td class="py-4 px-6 text-center">按主键大小有序插入</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">外键</td>
                            <td class="py-4 px-6 text-center text-red-500">不支持</td>
                            <td class="py-4 px-6 text-center text-green-500">支持</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">事务</td>
                            <td class="py-4 px-6 text-center text-red-500">不支持</td>
                            <td class="py-4 px-6 text-center text-green-500">支持</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">锁支持</td>
                            <td class="py-4 px-6 text-center">表级锁定</td>
                            <td class="py-4 px-6 text-center">行级锁定、表级锁定</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">索引实现</td>
                            <td class="py-4 px-6 text-center">B+树索引，非聚簇索引</td>
                            <td class="py-4 px-6 text-center">B+树索引，聚簇索引</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">全文索引</td>
                            <td class="py-4 px-6 text-center text-green-500">支持</td>
                            <td class="py-4 px-6 text-center">5.6后支持</td>
                        </tr>
                        <tr>
                            <td class="py-4 px-6 font-medium">清空表时</td>
                            <td class="py-4 px-6 text-center">重建表</td>
                            <td class="py-4 px-6 text-center">一行一行删除</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </section>

        <!-- Recommendation -->
        <section class="mb-16">
            <div class="bg-purple-50 rounded-xl p-8 shadow-lg card">
                <div class="flex items-center mb-6">
                    <i class="fas fa-lightbulb feature-icon mr-4 text-purple-500"></i>
                    <h3 class="text-2xl font-bold text-purple-800">选择建议</h3>
                </div>
                
                <div class="grid md:grid-cols-2 gap-8">
                    <div>
                        <h4 class="text-xl font-bold mb-4">何时选择InnoDB？</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>应用需要事务支持(如金融系统)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>高并发写入场景(如电商平台)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>需要数据完整性和外键约束</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>需要可靠的崩溃恢复机制</span>
                            </li>
                        </ul>
                    </div>
                    <div>
                        <h4 class="text-xl font-bold mb-4">何时选择MyISAM？</h4>
                        <ul class="space-y-3">
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>读取密集型应用(如博客、新闻)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>不需要事务支持的系统</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>需要全文索引(MySQL 5.6前)</span>
                            </li>
                            <li class="flex items-start">
                                <i class="fas fa-check text-purple-500 mt-1 mr-2"></i>
                                <span>存储空间受限的环境</span>
                            </li>
                        </ul>
                    </div>
                </div>
                
                <div class="mt-8 p-6 bg-white rounded-lg">
                    <h4 class="text-xl font-bold mb-3 text-center">混合使用策略</h4>
                    <p class="text-gray-700">
                        在某些场景下，可以混合使用两种存储引擎。例如，在电子商务网站中：
                    </p>
                    <div class="grid md:grid-cols-2 gap-4 mt-4">
                        <div class="bg-green-50 p-4 rounded-lg">
                            <h5 class="font-bold text-green-700">使用InnoDB</h5>
                            <p class="text-sm text-gray-700">订单管理、库存管理、支付处理等需要事务支持的部分</p>
                        </div>
                        <div class="bg-blue-50 p-4 rounded-lg">
                            <h5 class="font-bold text-blue-700">使用MyISAM</h5>
                            <p class="text-sm text-gray-700">产品目录、商品评论等读取密集且不需要事务的部分</p>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </main>

    <!-- Footer -->
    <footer class="bg-gray-900 text-gray-300 py-12 px-4">
        <div class="container mx-auto max-w-5xl text-center">
            <div class="flex flex-col md:flex-row justify-between items-center">
                <div class="mb-4 md:mb-0">
                    <h3 class="text-xl font-bold text-white mb-2">技术小馆</h3>
                    <p class="text-gray-400">专业的技术知识与资源分享平台</p>
                </div>
                <div>
                    <a href="http://www.yuque.com/jtostring" class="text-blue-400 hover:text-blue-300 transition-colors duration-300">
                        <i class="fas fa-external-link-alt mr-2"></i>访问技术小馆
                    </a>
                </div>
            </div>
            <div class="mt-8 pt-8 border-t border-gray-800 text-sm text-gray-500">
                &copy; 2023 技术小馆. 保留所有权利.
            </div>
        </div>
    </footer>

    <script>
        mermaid.initialize({
            startOnLoad: true,
            theme: 'default',
            flowchart: {
                useMaxWidth: false,
                htmlLabels: true,
                curve: 'basis'
            }
        });
    </script>
</body>
</html>
```